<?xml version="1.0" encoding="UTF-8"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1746.0">
   <BatchSequence>
      <Batch>
         <Statements>
            <StmtSimple StatementText="SELECT &#xA;    (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage&#xA;FROM&#xA;    Posts q&#xA;  INNER JOIN&#xA;    Posts a ON q.AcceptedAnswerId = a.Id&#xA;WHERE&#xA;    a.OwnerUserId = @UserId&#xA;  AND&#xA;    a.PostTypeId = 2" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSubTreeCost="665.983" StatementEstRows="1" StatementOptmLevel="FULL" QueryHash="0xFD105E12BF03EE90" QueryPlanHash="0x0FD74B49B05D3336">
               <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
               <QueryPlan DegreeOfParallelism="8" MemoryGrant="12736" CachedPlanSize="72" CompileTime="20" CompileCPU="20" CompileMemory="800">
                  <MissingIndexes>
                     <MissingIndexGroup Impact="99.9609">
                        <MissingIndex Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]">
                           <ColumnGroup Usage="EQUALITY">
                              <Column Name="[AcceptedAnswerId]" ColumnId="4" />
                           </ColumnGroup>
                        </MissingIndex>
                     </MissingIndexGroup>
                  </MissingIndexes>
                  <RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="15" EstimatedTotalSubtreeCost="665.983" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                     <OutputList>
                        <ColumnReference Column="Expr1010" />
                     </OutputList>
                     <ComputeScalar>
                        <DefinedValues>
                           <DefinedValue>
                              <ColumnReference Column="Expr1010" />
                              <ScalarOperator ScalarString="(CONVERT(float(53),[Expr1004],0)/CONVERT_IMPLICIT(float(53),[Expr1008],0))*(1.000000000000000e+002)">
                                 <Arithmetic Operation="MULT">
                                    <ScalarOperator>
                                       <Arithmetic Operation="DIV">
                                          <ScalarOperator>
                                             <Convert DataType="float" Scale="0" Style="0" Implicit="0">
                                                <ScalarOperator>
                                                   <Identifier>
                                                      <ColumnReference Column="Expr1004" />
                                                   </Identifier>
                                                </ScalarOperator>
                                             </Convert>
                                          </ScalarOperator>
                                          <ScalarOperator>
                                             <Convert DataType="float" Scale="0" Style="0" Implicit="1">
                                                <ScalarOperator>
                                                   <Identifier>
                                                      <ColumnReference Column="Expr1008" />
                                                   </Identifier>
                                                </ScalarOperator>
                                             </Convert>
                                          </ScalarOperator>
                                       </Arithmetic>
                                    </ScalarOperator>
                                    <ScalarOperator>
                                       <Const ConstValue="(1.000000000000000e+002)" />
                                    </ScalarOperator>
                                 </Arithmetic>
                              </ScalarOperator>
                           </DefinedValue>
                        </DefinedValues>
                        <RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="15" EstimatedTotalSubtreeCost="665.983" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                           <OutputList>
                              <ColumnReference Column="Expr1004" />
                              <ColumnReference Column="Expr1008" />
                           </OutputList>
                           <RunTimeInformation>
                              <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                           </RunTimeInformation>
                           <NestedLoops Optimized="0">
                              <RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="665.884" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                 <OutputList>
                                    <ColumnReference Column="Expr1004" />
                                 </OutputList>
                                 <ComputeScalar>
                                    <DefinedValues>
                                       <DefinedValue>
                                          <ColumnReference Column="Expr1004" />
                                          <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1012],0)">
                                             <Convert DataType="int" Style="0" Implicit="1">
                                                <ScalarOperator>
                                                   <Identifier>
                                                      <ColumnReference Column="globalagg1012" />
                                                   </Identifier>
                                                </ScalarOperator>
                                             </Convert>
                                          </ScalarOperator>
                                       </DefinedValue>
                                    </DefinedValues>
                                    <RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.9e-006" AvgRowSize="15" EstimatedTotalSubtreeCost="665.884" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Column="globalagg1012" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                       </RunTimeInformation>
                                       <StreamAggregate>
                                          <DefinedValues>
                                             <DefinedValue>
                                                <ColumnReference Column="globalagg1012" />
                                                <ScalarOperator ScalarString="SUM([partialagg1011])">
                                                   <Aggregate Distinct="0" AggType="SUM">
                                                      <ScalarOperator>
                                                         <Identifier>
                                                            <ColumnReference Column="partialagg1011" />
                                                         </Identifier>
                                                      </ScalarOperator>
                                                   </Aggregate>
                                                </ScalarOperator>
                                             </DefinedValue>
                                          </DefinedValues>
                                          <RelOp NodeId="5" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="4" EstimateIO="0" EstimateCPU="0.0285021" AvgRowSize="15" EstimatedTotalSubtreeCost="665.884" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                             <OutputList>
                                                <ColumnReference Column="partialagg1011" />
                                             </OutputList>
                                             <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
                                             </RunTimeInformation>
                                             <Parallelism>
                                                <RelOp NodeId="6" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="4" EstimateIO="0" EstimateCPU="8.03687e-005" AvgRowSize="15" EstimatedTotalSubtreeCost="665.856" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                   <OutputList>
                                                      <ColumnReference Column="partialagg1011" />
                                                   </OutputList>
                                                   <RunTimeInformation>
                                                      <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="3" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="4" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="5" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="7" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="8" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="2" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="6" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                   </RunTimeInformation>
                                                   <StreamAggregate>
                                                      <DefinedValues>
                                                         <DefinedValue>
                                                            <ColumnReference Column="partialagg1011" />
                                                            <ScalarOperator ScalarString="Count(*)">
                                                               <Aggregate AggType="countstar" Distinct="0" />
                                                            </ScalarOperator>
                                                         </DefinedValue>
                                                      </DefinedValues>
                                                      <RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="532.458" EstimateIO="0" EstimateCPU="23.0068" AvgRowSize="9" EstimatedTotalSubtreeCost="665.856" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                         <OutputList />
                                                         <MemoryFractions Input="0.925926" Output="1" />
                                                         <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="1" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="3" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="4" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="5" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="7" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="8" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="2" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="6" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                         </RunTimeInformation>
                                                         <Hash>
                                                            <DefinedValues />
                                                            <HashKeysBuild>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                            </HashKeysBuild>
                                                            <HashKeysProbe>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                            </HashKeysProbe>
                                                            <ProbeResidual>
                                                               <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[Id] as [a].[Id]=[StackOverflow.Exported].[dbo].[Posts].[AcceptedAnswerId] as [q].[AcceptedAnswerId]">
                                                                  <Compare CompareOp="EQ">
                                                                     <ScalarOperator>
                                                                        <Identifier>
                                                                           <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                        </Identifier>
                                                                     </ScalarOperator>
                                                                     <ScalarOperator>
                                                                        <Identifier>
                                                                           <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                                        </Identifier>
                                                                     </ScalarOperator>
                                                                  </Compare>
                                                               </ScalarOperator>
                                                            </ProbeResidual>
                                                            <RelOp NodeId="8" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="8.95665" EstimateIO="0" EstimateCPU="0.0285168" AvgRowSize="11" EstimatedTotalSubtreeCost="0.126942" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                               <OutputList>
                                                                  <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                               </OutputList>
                                                               <RunTimeInformation>
                                                                  <RunTimeCountersPerThread Thread="5" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="4" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="8" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="6" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="7" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="2" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="1" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="3" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                               </RunTimeInformation>
                                                               <Bitmap>
                                                                  <DefinedValues>
                                                                     <DefinedValue>
                                                                        <ColumnReference Column="Bitmap1015" />
                                                                     </DefinedValue>
                                                                  </DefinedValues>
                                                                  <HashKeys>
                                                                     <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                  </HashKeys>
                                                                  <RelOp NodeId="9" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8.95665" EstimateIO="0" EstimateCPU="0.0285168" AvgRowSize="11" EstimatedTotalSubtreeCost="0.126942" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                                     <OutputList>
                                                                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                     </OutputList>
                                                                     <RunTimeInformation>
                                                                        <RunTimeCountersPerThread Thread="5" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="4" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="8" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="6" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="7" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="2" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="3" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="1" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                     </RunTimeInformation>
                                                                     <Parallelism PartitioningType="Broadcast">
                                                                        <RelOp NodeId="10" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="0.0285076" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0984191" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                                           <OutputList>
                                                                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                           </OutputList>
                                                                           <RunTimeInformation>
                                                                              <RunTimeCountersPerThread Thread="1" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                                                              <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                           </RunTimeInformation>
                                                                           <Parallelism>
                                                                              <RelOp NodeId="11" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="1.31152e-005" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0699115" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                                                 <OutputList>
                                                                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                 </OutputList>
                                                                                 <RunTimeInformation>
                                                                                    <RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="8" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="3" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="2" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="6" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="4" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="1" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="5" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                                 </RunTimeInformation>
                                                                                 <NestedLoops Optimized="1">
                                                                                    <OuterReferences>
                                                                                       <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                    </OuterReferences>
                                                                                    <RelOp NodeId="13" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="0.0285235" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0318193" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                                                       <OutputList>
                                                                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                       </OutputList>
                                                                                       <RunTimeInformation>
                                                                                          <RunTimeCountersPerThread Thread="7" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="3" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="4" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="8" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="2" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="6" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="1" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="5" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                          <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                                       </RunTimeInformation>
                                                                                       <Parallelism PartitioningType="RoundRobin">
                                                                                          <RelOp NodeId="14" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="12.5504" EstimateIO="0.003125" EstimateCPU="0.000170805" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00329581" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                                                                             <OutputList>
                                                                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                             </OutputList>
                                                                                             <RunTimeInformation>
                                                                                                <RunTimeCountersPerThread Thread="1" ActualRows="181" ActualEndOfScans="1" ActualExecutions="1" />
                                                                                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                                             </RunTimeInformation>
                                                                                             <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                                                                <DefinedValues>
                                                                                                   <DefinedValue>
                                                                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                                   </DefinedValue>
                                                                                                </DefinedValues>
                                                                                                <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxPostOwner]" Alias="[a]" IndexKind="NonClustered" />
                                                                                                <SeekPredicates>
                                                                                                   <SeekPredicateNew>
                                                                                                      <SeekKeys>
                                                                                                         <Prefix ScanType="EQ">
                                                                                                            <RangeColumns>
                                                                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="OwnerUserId" />
                                                                                                            </RangeColumns>
                                                                                                            <RangeExpressions>
                                                                                                               <ScalarOperator ScalarString="[@UserId]">
                                                                                                                  <Identifier>
                                                                                                                     <ColumnReference Column="@UserId" />
                                                                                                                  </Identifier>
                                                                                                               </ScalarOperator>
                                                                                                            </RangeExpressions>
                                                                                                         </Prefix>
                                                                                                      </SeekKeys>
                                                                                                   </SeekPredicateNew>
                                                                                                </SeekPredicates>
                                                                                             </IndexScan>
                                                                                          </RelOp>
                                                                                       </Parallelism>
                                                                                    </RelOp>
                                                                                    <RelOp NodeId="16" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="8.95665" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0380791" TableCardinality="4.18708e+006" Parallel="1" EstimateRebinds="11.5504" EstimateRewinds="0">
                                                                                       <OutputList />
                                                                                       <RunTimeInformation>
                                                                                          <RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="1" ActualExecutions="22" />
                                                                                          <RunTimeCountersPerThread Thread="8" ActualRows="20" ActualEndOfScans="2" ActualExecutions="22" />
                                                                                          <RunTimeCountersPerThread Thread="3" ActualRows="21" ActualEndOfScans="2" ActualExecutions="23" />
                                                                                          <RunTimeCountersPerThread Thread="2" ActualRows="21" ActualEndOfScans="2" ActualExecutions="23" />
                                                                                          <RunTimeCountersPerThread Thread="6" ActualRows="21" ActualEndOfScans="1" ActualExecutions="22" />
                                                                                          <RunTimeCountersPerThread Thread="4" ActualRows="20" ActualEndOfScans="3" ActualExecutions="23" />
                                                                                          <RunTimeCountersPerThread Thread="1" ActualRows="20" ActualEndOfScans="3" ActualExecutions="23" />
                                                                                          <RunTimeCountersPerThread Thread="5" ActualRows="22" ActualEndOfScans="1" ActualExecutions="23" />
                                                                                          <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                                                       </RunTimeInformation>
                                                                                       <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                                                          <DefinedValues />
                                                                                          <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" Alias="[a]" TableReferenceId="-1" IndexKind="Clustered" />
                                                                                          <SeekPredicates>
                                                                                             <SeekPredicateNew>
                                                                                                <SeekKeys>
                                                                                                   <Prefix ScanType="EQ">
                                                                                                      <RangeColumns>
                                                                                                         <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                                      </RangeColumns>
                                                                                                      <RangeExpressions>
                                                                                                         <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[Id] as [a].[Id]">
                                                                                                            <Identifier>
                                                                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="Id" />
                                                                                                            </Identifier>
                                                                                                         </ScalarOperator>
                                                                                                      </RangeExpressions>
                                                                                                   </Prefix>
                                                                                                </SeekKeys>
                                                                                             </SeekPredicateNew>
                                                                                          </SeekPredicates>
                                                                                          <Predicate>
                                                                                             <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[PostTypeId] as [a].[PostTypeId]=(2)">
                                                                                                <Compare CompareOp="EQ">
                                                                                                   <ScalarOperator>
                                                                                                      <Identifier>
                                                                                                         <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[a]" Column="PostTypeId" />
                                                                                                      </Identifier>
                                                                                                   </ScalarOperator>
                                                                                                   <ScalarOperator>
                                                                                                      <Const ConstValue="(2)" />
                                                                                                   </ScalarOperator>
                                                                                                </Compare>
                                                                                             </ScalarOperator>
                                                                                          </Predicate>
                                                                                       </IndexScan>
                                                                                    </RelOp>
                                                                                 </NestedLoops>
                                                                              </RelOp>
                                                                           </Parallelism>
                                                                        </RelOp>
                                                                     </Parallelism>
                                                                  </RelOp>
                                                               </Bitmap>
                                                            </RelOp>
                                                            <RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4.18708e+006" EstimateIO="641.571" EstimateCPU="1.15149" AvgRowSize="11" EstimatedTotalSubtreeCost="642.722" TableCardinality="4.18708e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                               <OutputList>
                                                                  <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                               </OutputList>
                                                               <RunTimeInformation>
                                                                  <RunTimeCountersPerThread Thread="5" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="4" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="2" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="7" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="1" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="3" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="8" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="6" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                               </RunTimeInformation>
                                                               <IndexScan Ordered="0" ForcedIndex="0" NoExpandHint="0">
                                                                  <DefinedValues>
                                                                     <DefinedValue>
                                                                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                                     </DefinedValue>
                                                                  </DefinedValues>
                                                                  <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" Alias="[q]" IndexKind="Clustered" />
                                                                  <Predicate>
                                                                     <ScalarOperator ScalarString="PROBE([Bitmap1015],[StackOverflow.Exported].[dbo].[Posts].[AcceptedAnswerId] as [q].[AcceptedAnswerId],N'[IN ROW]')">
                                                                        <Intrinsic FunctionName="PROBE">
                                                                           <ScalarOperator>
                                                                              <Identifier>
                                                                                 <ColumnReference Column="Bitmap1015" />
                                                                              </Identifier>
                                                                           </ScalarOperator>
                                                                           <ScalarOperator>
                                                                              <Identifier>
                                                                                 <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[q]" Column="AcceptedAnswerId" />
                                                                              </Identifier>
                                                                           </ScalarOperator>
                                                                           <ScalarOperator>
                                                                              <Const ConstValue="N'[IN ROW]'" />
                                                                           </ScalarOperator>
                                                                        </Intrinsic>
                                                                     </ScalarOperator>
                                                                  </Predicate>
                                                               </IndexScan>
                                                            </RelOp>
                                                         </Hash>
                                                      </RelOp>
                                                   </StreamAggregate>
                                                </RelOp>
                                             </Parallelism>
                                          </RelOp>
                                       </StreamAggregate>
                                    </RelOp>
                                 </ComputeScalar>
                              </RelOp>
                              <RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5.87399e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0984289" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                 <OutputList>
                                    <ColumnReference Column="Expr1008" />
                                 </OutputList>
                                 <ComputeScalar>
                                    <DefinedValues>
                                       <DefinedValue>
                                          <ColumnReference Column="Expr1008" />
                                          <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1016],0)">
                                             <Convert DataType="int" Style="0" Implicit="1">
                                                <ScalarOperator>
                                                   <Identifier>
                                                      <ColumnReference Column="Expr1016" />
                                                   </Identifier>
                                                </ScalarOperator>
                                             </Convert>
                                          </ScalarOperator>
                                       </DefinedValue>
                                    </DefinedValues>
                                    <RelOp NodeId="29" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="5.87399e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0984289" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Column="Expr1016" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                                       </RunTimeInformation>
                                       <StreamAggregate>
                                          <DefinedValues>
                                             <DefinedValue>
                                                <ColumnReference Column="Expr1016" />
                                                <ScalarOperator ScalarString="Count(*)">
                                                   <Aggregate AggType="countstar" Distinct="0" />
                                                </ScalarOperator>
                                             </DefinedValue>
                                          </DefinedValues>
                                          <RelOp NodeId="30" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="0.0285054" AvgRowSize="9" EstimatedTotalSubtreeCost="0.098417" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                             <OutputList />
                                             <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                             </RunTimeInformation>
                                             <Parallelism>
                                                <RelOp NodeId="31" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="1.31152e-005" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0699115" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                   <OutputList />
                                                   <RunTimeInformation>
                                                      <RunTimeCountersPerThread Thread="4" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="8" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="6" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="3" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="2" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="5" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="1" ActualRows="20" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
                                                      <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                   </RunTimeInformation>
                                                   <NestedLoops Optimized="1">
                                                      <OuterReferences>
                                                         <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                      </OuterReferences>
                                                      <RelOp NodeId="33" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="0.0285235" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0318193" Parallel="1" EstimateRebinds="0" EstimateRewinds="0">
                                                         <OutputList>
                                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                         </OutputList>
                                                         <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="4" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="8" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="6" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="7" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="5" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="2" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="1" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="3" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                         </RunTimeInformation>
                                                         <Parallelism PartitioningType="RoundRobin">
                                                            <RelOp NodeId="34" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="12.5504" EstimateIO="0.003125" EstimateCPU="0.000170805" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00329581" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                                               <OutputList>
                                                                  <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                               </OutputList>
                                                               <RunTimeInformation>
                                                                  <RunTimeCountersPerThread Thread="1" ActualRows="181" ActualEndOfScans="1" ActualExecutions="1" />
                                                                  <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                               </RunTimeInformation>
                                                               <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                                  <DefinedValues>
                                                                     <DefinedValue>
                                                                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                                     </DefinedValue>
                                                                  </DefinedValues>
                                                                  <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxPostOwner]" IndexKind="NonClustered" />
                                                                  <SeekPredicates>
                                                                     <SeekPredicateNew>
                                                                        <SeekKeys>
                                                                           <Prefix ScanType="EQ">
                                                                              <RangeColumns>
                                                                                 <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="OwnerUserId" />
                                                                              </RangeColumns>
                                                                              <RangeExpressions>
                                                                                 <ScalarOperator ScalarString="[@UserId]">
                                                                                    <Identifier>
                                                                                       <ColumnReference Column="@UserId" />
                                                                                    </Identifier>
                                                                                 </ScalarOperator>
                                                                              </RangeExpressions>
                                                                           </Prefix>
                                                                        </SeekKeys>
                                                                     </SeekPredicateNew>
                                                                  </SeekPredicates>
                                                               </IndexScan>
                                                            </RelOp>
                                                         </Parallelism>
                                                      </RelOp>
                                                      <RelOp NodeId="36" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="8.95665" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0380791" TableCardinality="4.18708e+006" Parallel="1" EstimateRebinds="11.5504" EstimateRewinds="0">
                                                         <OutputList />
                                                         <RunTimeInformation>
                                                            <RunTimeCountersPerThread Thread="4" ActualRows="20" ActualEndOfScans="3" ActualExecutions="23" />
                                                            <RunTimeCountersPerThread Thread="6" ActualRows="21" ActualEndOfScans="1" ActualExecutions="22" />
                                                            <RunTimeCountersPerThread Thread="8" ActualRows="20" ActualEndOfScans="2" ActualExecutions="22" />
                                                            <RunTimeCountersPerThread Thread="3" ActualRows="21" ActualEndOfScans="2" ActualExecutions="23" />
                                                            <RunTimeCountersPerThread Thread="2" ActualRows="21" ActualEndOfScans="2" ActualExecutions="23" />
                                                            <RunTimeCountersPerThread Thread="5" ActualRows="22" ActualEndOfScans="1" ActualExecutions="23" />
                                                            <RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="1" ActualExecutions="22" />
                                                            <RunTimeCountersPerThread Thread="1" ActualRows="20" ActualEndOfScans="3" ActualExecutions="23" />
                                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                                         </RunTimeInformation>
                                                         <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                            <DefinedValues />
                                                            <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" TableReferenceId="-1" IndexKind="Clustered" />
                                                            <SeekPredicates>
                                                               <SeekPredicateNew>
                                                                  <SeekKeys>
                                                                     <Prefix ScanType="EQ">
                                                                        <RangeColumns>
                                                                           <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                                        </RangeColumns>
                                                                        <RangeExpressions>
                                                                           <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[Id]">
                                                                              <Identifier>
                                                                                 <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="Id" />
                                                                              </Identifier>
                                                                           </ScalarOperator>
                                                                        </RangeExpressions>
                                                                     </Prefix>
                                                                  </SeekKeys>
                                                               </SeekPredicateNew>
                                                            </SeekPredicates>
                                                            <Predicate>
                                                               <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[PostTypeId]=(2)">
                                                                  <Compare CompareOp="EQ">
                                                                     <ScalarOperator>
                                                                        <Identifier>
                                                                           <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Column="PostTypeId" />
                                                                        </Identifier>
                                                                     </ScalarOperator>
                                                                     <ScalarOperator>
                                                                        <Const ConstValue="(2)" />
                                                                     </ScalarOperator>
                                                                  </Compare>
                                                               </ScalarOperator>
                                                            </Predicate>
                                                         </IndexScan>
                                                      </RelOp>
                                                   </NestedLoops>
                                                </RelOp>
                                             </Parallelism>
                                          </RelOp>
                                       </StreamAggregate>
                                    </RelOp>
                                 </ComputeScalar>
                              </RelOp>
                           </NestedLoops>
                        </RelOp>
                     </ComputeScalar>
                  </RelOp>
                  <ParameterList>
                     <ColumnReference Column="@UserId" ParameterRuntimeValue="(1)" />
                  </ParameterList>
               </QueryPlan>
            </StmtSimple>
         </Statements>
      </Batch>
   </BatchSequence>
</ShowPlanXML>